/*==============================================================*/
/* DBMS name:      ORACLE Version 9i2                           */
/* Created on:     2/8/2009 11:30:03 PM                         */
/* Created by:     Team Retral                                  */
/*==============================================================*/


INSERT INTO ROLE (ROLE_CODE, ROLE_DESCRIPTION, INPUT_QUESTION, DELETE_QUESTION, VIEW_USERS, ADD_DELETE_USER, GENERATE_APE, INPUT_SCORES, VIEW_SCORES) 
VALUES ('admin', 'APE Generation System Administrator', 1, 1, 1, 1, 1, 1, 1);

INSERT INTO ROLE (ROLE_CODE, ROLE_DESCRIPTION, INPUT_QUESTION, DELETE_QUESTION, VIEW_USERS, ADD_DELETE_USER, GENERATE_APE, INPUT_SCORES, VIEW_SCORES) 
VALUES ('facul', 'EWU Computer Science Faculty Member', 1, 1, 0, 0, 1, 1, 0);

------------------------------------------------------------------------------------------------------------------------------



INSERT INTO APE_USER (USER_ID, ROLE_CODE, PASSWORD_HASH, FIRST_NAME, LAST_NAME) 
VALUES (user_s1.nextval, 'admin', 'f3e731dfa293c7a83119d8aacfa41b5d2d780be9', 'Jeff', 'Putnam');

INSERT INTO APE_USER (USER_ID, ROLE_CODE, PASSWORD_HASH, FIRST_NAME, LAST_NAME) 
VALUES (user_s1.nextval, 'admin', '96835dd8bfa718bd6447ccc87af89ae1675daeca', 'Tom', 'Capaul');

INSERT INTO APE_USER (USER_ID, ROLE_CODE, PASSWORD_HASH, FIRST_NAME, LAST_NAME) 
VALUES (user_s1.nextval, 'facul', '4dc50fc3bc007be011b5445f3f79298b9eeb51b7', 'Stu', 'Steiner');

INSERT INTO APE_USER (USER_ID, ROLE_CODE, PASSWORD_HASH, FIRST_NAME, LAST_NAME) 
VALUES (user_s1.nextval, 'facul', 'a51dda7c7ff50b61eaea0444371f4a6a9301e501', 'John', 'Doe');



------------------------------------------------------------------------------------------------------------------------------



INSERT INTO STUDENT_USER (STUDENT_ID, PASSWORD_HASH) 
VALUES (student_s1.nextval, '204036a1ef6e7360e536300ea78c6aeb4a9333dd');

INSERT INTO STUDENT_USER (STUDENT_ID, PASSWORD_HASH) 
VALUES (student_s1.nextval, '204036a1ef6e7360e536300ea78c6aeb4a9333dd');

INSERT INTO STUDENT_USER (STUDENT_ID, PASSWORD_HASH) 
VALUES (student_s1.nextval, '204036a1ef6e7360e536300ea78c6aeb4a9333dd');

INSERT INTO STUDENT_USER (STUDENT_ID, PASSWORD_HASH) 
VALUES (student_s1.nextval, '204036a1ef6e7360e536300ea78c6aeb4a9333dd');

INSERT INTO STUDENT_USER (STUDENT_ID, PASSWORD_HASH) 
VALUES (student_s1.nextval, '204036a1ef6e7360e536300ea78c6aeb4a9333dd');

INSERT INTO STUDENT_USER (STUDENT_ID, PASSWORD_HASH) 
VALUES (student_s1.nextval, '204036a1ef6e7360e536300ea78c6aeb4a9333dd');

INSERT INTO STUDENT_USER (STUDENT_ID, PASSWORD_HASH) 
VALUES (student_s1.nextval, '204036a1ef6e7360e536300ea78c6aeb4a9333dd');

INSERT INTO STUDENT_USER (STUDENT_ID, PASSWORD_HASH) 
VALUES (student_s1.nextval, '204036a1ef6e7360e536300ea78c6aeb4a9333dd');

INSERT INTO STUDENT_USER (STUDENT_ID, PASSWORD_HASH) 
VALUES (student_s1.nextval, '204036a1ef6e7360e536300ea78c6aeb4a9333dd');

INSERT INTO STUDENT_USER (STUDENT_ID, PASSWORD_HASH) 
VALUES (student_s1.nextval, '204036a1ef6e7360e536300ea78c6aeb4a9333dd');

INSERT INTO STUDENT_USER (STUDENT_ID, PASSWORD_HASH) 
VALUES (student_s1.nextval, '204036a1ef6e7360e536300ea78c6aeb4a9333dd');

INSERT INTO STUDENT_USER (STUDENT_ID, PASSWORD_HASH) 
VALUES (student_s1.nextval, '204036a1ef6e7360e536300ea78c6aeb4a9333dd');

INSERT INTO STUDENT_USER (STUDENT_ID, PASSWORD_HASH) 
VALUES (student_s1.nextval, '204036a1ef6e7360e536300ea78c6aeb4a9333dd');



------------------------------------------------------------------------------------------------------------------------------



INSERT INTO QUESTION_TYPE (TYPE_CODE, TYPE_DESCRIPTION, POINTS) VALUES (1, 'LinkedList Operations', 30);

INSERT INTO QUESTION_TYPE (TYPE_CODE, TYPE_DESCRIPTION, POINTS) VALUES (2, 'Recursion Operations', 20);

INSERT INTO QUESTION_TYPE (TYPE_CODE, TYPE_DESCRIPTION, POINTS) VALUES (3, 'Abstrectation Operations', 30);

INSERT INTO QUESTION_TYPE (TYPE_CODE, TYPE_DESCRIPTION, POINTS) VALUES (4, 'General Operations', 20);


------------------------------------------------------------------------------------------------------------------------------

INSERT INTO REVISION_TYPE (REQUEST_CODE, TYPE_DESCRIPTION, REV_TYPE) VALUES (1, 'Question Deleted', 0);

INSERT INTO REVISION_TYPE (REQUEST_CODE, TYPE_DESCRIPTION, REV_TYPE) VALUES (2, 'New Question', 1);

INSERT INTO REVISION_TYPE (REQUEST_CODE, TYPE_DESCRIPTION, REV_TYPE) VALUES (3, 'Correction to Files', 1);

INSERT INTO REVISION_TYPE (REQUEST_CODE, TYPE_DESCRIPTION, REV_TYPE) VALUES (4, 'Delete Question', 1);

INSERT INTO REVISION_TYPE (REQUEST_CODE, TYPE_DESCRIPTION, REV_TYPE) VALUES (5, 'Does not Compile', 2);

INSERT INTO REVISION_TYPE (REQUEST_CODE, TYPE_DESCRIPTION, REV_TYPE) VALUES (6, 'Incomplete Information', 2);

INSERT INTO REVISION_TYPE (REQUEST_CODE, TYPE_DESCRIPTION, REV_TYPE) VALUES (7, 'Approved', 3);

INSERT INTO REVISION_TYPE (REQUEST_CODE, TYPE_DESCRIPTION, REV_TYPE) VALUES (8, 'Needs Improvement', 3);

INSERT INTO REVISION_TYPE (REQUEST_CODE, TYPE_DESCRIPTION, REV_TYPE) VALUES (9, 'Remove', 3);

------------------------------------------------------------------------------------------------------------------------------

INSERT INTO NAV_URLS(PAGE_NAME, PAGE_URL, ADMIN, FACUL) VALUES ('Generate','?page=generate',1,1);
INSERT INTO NAV_URLS(PAGE_NAME, PAGE_URL, ADMIN, FACUL) VALUES ('Add Question','?page=addQuestionHome',1,1);
INSERT INTO NAV_URLS(PAGE_NAME, PAGE_URL, ADMIN, FACUL) VALUES ('Preview','?page=preview',1,1);
INSERT INTO NAV_URLS(PAGE_NAME, PAGE_URL, ADMIN, FACUL) VALUES ('Exams','?page=exams', 1, 1);
INSERT INTO NAV_URLS(PAGE_NAME, PAGE_URL, ADMIN, FACUL) VALUES ('Approve','?page=request',1,0);
INSERT INTO NAV_URLS(PAGE_NAME, PAGE_URL, ADMIN, FACUL) VALUES ('Pending','?page=pendingCompletion',1,1);

INSERT INTO STUDENT_URLS(PAGE_NAME, PAGE_URL) VALUES ('Scores','?page=scores');
commit;
------------------------------------------------------------------------------------------------------------------------------
